
	
/****** Object:  Stored Procedure [sapro].DanhMucUpdate    Script Date: Thursday, March 18, 2010 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spDanhMucUpdate]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [sapro].[spDanhMucUpdate]
GO
			
	
	

	
/******************************************************************************
**		File: 
**		Name: [sapro].spDanhMucUpdate
**		Desc: 
**
**		Return values:
** 
**		Called by:   
**              
**		Parameters:
**		Input							Output
**     ----------							-----------
**
**		Auth: CodeSmith
**		Date: 3/18/2010 5:03:38 PM
*******************************************************************************
**		Change History
*******************************************************************************
**		Date:		Author:				Description:
**		--------		--------				-------------------------------------------
**    
*******************************************************************************/
CREATE PROCEDURE [sapro].spDanhMucUpdate
	@MaDanhMuc int, 
	@TenDanhMuc nvarchar(150), 
	@ThuocDanhMuc int, 
	@LoaiDanhMuc int 
AS

UPDATE [sapro].[DanhMuc] SET
	[TenDanhMuc] = @TenDanhMuc,
	[ThuocDanhMuc] = @ThuocDanhMuc,
	[LoaiDanhMuc] = @LoaiDanhMuc
WHERE
	[MaDanhMuc] = @MaDanhMuc

GO

